FINS Financial Institutions System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| map-get-institutions-response | Query Financial Institution Mapping from Core Banking System This dwl file is used by endpoints get:/institution/(institutionid) & get:/institutions |
| map-create-institutions-payload | Create Institution Mapping for Core Banking System. Maps Banking Spec Account JSON to JSON which is used by stored procedure sp_FinancialInstitution_Upsert. |
map-get-institutions-response
Query Financial Institution Mapping from Core Banking System
This dwl file is used by endpoints get:/institution/(institutionid) & get:/institutions
Source:
./src/main/resources/dwl/map-get-institutions-response.dwl
map-create-institutions-payload
Create Institution Mapping for Core Banking System.
Maps Banking Spec Account JSON to JSON which is used by stored procedure sp_FinancialInstitution_Upsert.
Source:
./src/main/resources/dwl/map-create-institutions-payload.dwl
Mapping Tables
Maps FinancialInstitution spec to JSON which is used by stored procedure - sp_FinancialInstitution_Upsert
| Institution Spec Field | Core Banking DB Field | Description |
|---|---|---|
| id | ID | Institution id |
| name | NAME | name related to the institution |
| institutionType | DESCRIPTION | descriptrion about the institution |
| bankCode | CHECK_NUMBER | bank code associated with this institution |
| headquartersCountry | HEADQUARTERS_COUNTRY | Headquarter country of the institution |
| headquartersRegion | HEADQUARTERS_REGION | Headquarter region of the institution |
| headquartersCity | HEADQUARTERS_CITY | Headquarter city of the institution |
| globalInstitutionId | GLOBAL_INSTITUTION_ID | externalId of the institution |
| auditInfo.createdBy | CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.createdDate | CREATED_DATETimestamp of when the entity was created - default as current timestamp | |
| auditInfo.updatedBy | UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.updatedDate | UPDATED_DATE | Timestamp of when the entity was last updated |
| auditInfo.isDeleted | isDeleted | Indicates whether or not the entity has been soft-deleted - default as false |